Excel Functions: For the Every Day User by Robin Hunt

Author:Robin Hunt [Hunt, Robin]
Language: eng
Format: azw3
Publisher: UNKNOWN
Published: 2017-05-15T04:00:00+00:00

PIVOT TABLES

A PivotTable report is an interactive way to quickly summarize large amounts of data. Use a PivotTable report to analyze numerical data in detail and to answer unanticipated questions about your data. A PivotTable report is especially designed for:

• Querying large amounts of data in many user-friendly ways.

• Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.

• Expanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you.

• Moving rows to columns or columns to rows (or “pivoting”) to see different summaries of the source data.

• Filtering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data to enable you to focus on the information that you want.

• Presenting concise, attractive, and annotated online or printed reports.

For more information, go to: http://office.microsoft.com/en-us/excel/HP101773841033.aspx

CREATE A PIVOT TABLE Pivots have four basic parts: Data, Rows, Columns and Summarized fields. People create “pivot” type displays all the time.

The table below could easily be accomplished by using the Pivot table command instead of typing it up manually

- assuming you have the data to supply it. The Person is listed in the row headings; the months are listed in the columns headings; and the numbers are the in summarized field.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.